Online Analytical Processing (OLAP) for Decision Support
نویسندگان
چکیده
Nenad Jukic 1 , Boris Jukic 2 , and Mary Malliaris 1 School of Business Administration, Loyola University Chicago, Chicago, IL, USA School of Business, Clarkson University, Potsdam, NY, USA _____________________________________________________________________________________ Online Analytical Processing (OLAP) refers to the general activity of querying and presenting text and number data from data warehouses and/or data marts for analytical purposes. This chapter gives an overview of OLAP and explains how it is used for decision support. Before the specific OLAP functions and platforms are presented, the connection between the OLAP systems and analytical data repositories is covered. Then, an overview of functionalities that are common for all OLAP tools is presented.
منابع مشابه
Data Warehousing, Data Mining, OLAP and OLTP Technologies Are Indispensable Elements to Support Decision-Making Process in Industrial World
This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, new applications and the architecture of Data Warehousing and data mining. The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the online transaction processing (OLTP) applications ...
متن کاملData Warehousing Applications: an Analytical Tool for Decision Support System
Data-driven decision support systems, such as data warehouses can serve the requirement of extraction of information from more than one subject area. Data warehouses standardize the data across the organization so as to have a single view of information. Data warehouses (DW) can provide the information required by the decision makers. The data warehouse supports an on-line analytical processing...
متن کاملClinical Decision Support System Using OLAP Mining
The healthcare industry collects huge amounts of data which, unfortunately, are not turned into useful information for effective decision making. Clinical Decision support systems (CDSS) can now use advanced technologies such as On-Line Analytical Processing (OLAP) and Data Mining to deliver advanced capabilities. This paper presents a prototype CDSS using OLAP with Data Mining (OLAP Mining) wh...
متن کاملClinical Decision Support Using OLAP With Data Mining
The healthcare industry collects huge amounts of data which, unfortunately, are not turned into useful information for effective decision making. Decision support systems (DSS) can now use advanced technologies such as On-Line Analytical Processing (OLAP) and data mining to deliver advanced capabilities. This paper presents a prototype clinical decision support system which combines the strengt...
متن کاملParallel data cube construction for high performance on-line analytical processing
Decision support systems use On-Line Analytical Processing (OLAP) to analyze data by posing complex queries that require diierent views of data. Traditionally , a relational approach (ROLAP) has been taken to build such systems. More recently, multi-dimensional database techniques (MOLAP) have been applied to decision-support applications. Data is stored in multi-dimensional arrays which is a n...
متن کامل